The base class of any Diamant ORM DAO in which persistence operations for SQL Server data stores are automatically created by inferring data schema in accordance with TEntity characteristics.

The following tables list the members exposed by the ConventionFirstSqlDao<TEntity> type.

Constructors
Name Description
Public constructor ConventionFirstSqlDao<TEntity> (Overloaded) Creates a new ConventionFirstSqlDao<TEntity, TEntityId> instance.
Top
Properties
Name Description
Public property Carbonite Gets the carbonite controller that hosts the current DAO and offers data store context to it. (inherited from BaseDao<TDataContext, TCarboniteController, TTransaction, TTransactionCreationParameters>).
Protected property ColumnNames Gets the column names to create SQL SELECT statements. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected property ColumnNamesAndExpressions Gets the column names and expressions to create SQL SELECT statements. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected property Entities Routes an entity read request to the underlying relational data store, so that all TEntity entities are obtained. (inherited from DiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected property InsertionColumnNames Gets the insertion column names to create SQL INSERT statements. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected property PrimaryKeyColumnsAndCommandParameterNames Gets the primary key columns and command parameter names to create SQL WHERE clauses. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected property TableMappings Gets the concrete table mappings to automatically configure create, read, update and delete SQL commands. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Top
Methods
Name Description
Public method Add (Overloaded) Routes an entity creation request to the underlying data store. (inherited from Dao<TEntity, TEntityCollection, TDataContext, TFilteringCriteria, TOrderingCriteria, TPagingCriteria, TCarboniteController, TTransaction, TTransactionCreationParameters>).
Protected method Column Allows to configure a object-relational bilateral mapping. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Public method Count (Overloaded) Routes an entity count request to the underlying data store, so that all TEntity entities are counted. (inherited from Dao<TEntity, TEntityCollection, TDataContext, TFilteringCriteria, TOrderingCriteria, TPagingCriteria, TCarboniteController, TTransaction, TTransactionCreationParameters>).
Public method Equals (Overloaded) Determines whether the specified object is equal to the current object. (inherited from Object).
Protected method Expression Allows to configure a object-relational unilateral mapping, so that a given SQL expression controls the value of an entity property. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (inherited from Object).
Public method Get (Overloaded) Routes an entity read request to the underlying data store, so that all TEntity entities are obtained. (inherited from Dao<TEntity, TEntityCollection, TDataContext, TFilteringCriteria, TOrderingCriteria, TPagingCriteria, TCarboniteController, TTransaction, TTransactionCreationParameters>).
Public method GetFirst (Overloaded) Routes an entity read request to the underlying data store, so that the first TEntity is obtained. (inherited from Dao<TEntity, TEntityCollection, TDataContext, TFilteringCriteria, TOrderingCriteria, TPagingCriteria, TCarboniteController, TTransaction, TTransactionCreationParameters>).
Public method GetHashCode Serves as the default hash function. (inherited from Object).
Public method GetType (Overloaded) Gets the Type of the current instance. (inherited from Object).
Public method Initialize Initializes the current DAO with the specified host carbonite controller as its data store context provider. (inherited from BaseDao<TDataContext, TCarboniteController, TTransaction, TTransactionCreationParameters>).
Protected method MapColumnAndParameterNamesInTextualPredicate Replaces the entity property names expressed as SomeProperty=@SomeProperty pairs in the given textual predicate, with the names of its equivalent table columns according with the TableMappings. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method MapColumnNamesInTextualOrderingCriteria Replaces the entity property names in the given textual ordering criteria, with the names of its equivalent table columns according with the TableMappings. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method MapCommandParametersFromEntityProperties Configures the SQL command parameters according to the given entity properties. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method MapCommandParametersFromPredicate Configures the SQL command parameters according to the given filtering criteria expressed with entity property names. In the command, filtering criteria parameters are converted to its equivalent table columns according with the TableMappings. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method MapCommandPrimaryKeyParameterFromEntityId Configures the SQL command parameters that represents primary keys, according to the given entity id properties. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method MemberwiseClone Creates a shallow copy of the current Object. (inherited from Object).
Protected method OnAdd (Overloaded) By obtaining for each entity a data command via OnConfigureInsertCommand(TDataCommand,TEntity) and then running that command, this inversion control method handles the request to create a set of entities into the underlying relational data store. (inherited from DiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method OnAreEqual By comparing the identities of two entities, this inversion control method handles the request to determine if those are equal.

The identity of each entity is obtained by reading a property named "Id", if present. (inherited from Dao<TEntity, TEntityCollection, TDataContext, TFilteringCriteria, TOrderingCriteria, TPagingCriteria, TCarboniteController, TTransaction, TTransactionCreationParameters>).
Protected method OnBuildSelectedEntity By using the configured table mappings of OnGetMappings, this inversion control method automatically unpacks relational data into a new instance of TEntity (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method OnConfigureCountCommand (Overloaded) By using the configured table mappings of OnGetMappings, this inversion control method automatically produces an SQL SELECT COUNT command that handles the request to configure an all entity count command in the underlying relational data store. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method OnConfigureDeleteCommand (Overloaded) By using the configured table mappings of OnGetMappings, this inversion control method automatically produces an SQL DELETE command that handles the request to configure a delete all entities command from the underlying relational data store. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method OnConfigureInsertCommand By using the configured table mappings of OnGetMappings, this inversion control method automatically produces an SQL INSERT command that handles the request to configure an entity creation command in the underlying relational data store. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method OnConfigureSelectCommand (Overloaded) By using the configured table mappings of ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, OnGetMappings, this inversion control method automatically produces an SQL SELECT command that handles the request to configure a read command for all entities in the segment defined by Paging and in compliance with the Where filter from SQL Server.

Read entities are sorted according to the OrderBy criteria. (inherited from ConfigurationFirstSqlDao<TEntity>).
Protected method OnConfigureUpdateCommand By using the configured table mappings of OnGetMappings, this inversion control method automatically produces an SQL UPDATE command that handles the request to configure an entity update command in the underlying relational data store. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method OnCount (Overloaded) By obtaining a data command via OnConfigureCountCommand(TDataCommand) and then running that command, this inversion control method handles the request to count all TEntity entities in the underlying relational data store. (inherited from DiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method OnFormatCommandParameterName By expressing a text in a valid way for the underlying relational data store syntax, this inversion control method handles the request to format an SQL command parameter name. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method OnFormatCommandParameterValue By expressing a .NET native data type value in a valid way for the underlying relational data store syntax, this inversion control method handles the request to format an SQL command parameter name. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method OnGet (Overloaded) By obtaining a data command via OnConfigureSelectCommand(TDataCommand) and then running that command, this inversion control method handles the request to obtain all TEntity entities from the underlying relational data store. (inherited from DiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method OnGetFirst (Overloaded) By calling the Get method to retrieve all TEntity entities and then picking the first of them, this inversion control method handles the request to obtain the first from the underlying data store. (inherited from Dao<TEntity, TEntityCollection, TDataContext, TFilteringCriteria, TOrderingCriteria, TPagingCriteria, TCarboniteController, TTransaction, TTransactionCreationParameters>).
Protected method OnGetMappings By returning the set of object-relational bilateral mappings from ConventionFirstDiamantDaoContext<TEntity>, this inversion control method handles the request to get the TableMappings for this DAO to function.
Protected method OnInitialize Handles the request to initialize the current DAO. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method OnMapColumnToProperty By converting to .NET data types a native value from the underlying data store, this inversion control method handles the request to map a data column into the corresponding TEntity property according to the configured TableMappings. (inherited from ConfigurationFirstDiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method OnPostconfigureCommand Handles the request to postconfigure a data command suitable for the underlying relational data store.

This method is always called after every OnConfigureXxxCommand. (inherited from DiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method OnPreconfigureCommand Handles the request to preconfigure a data command suitable for the underlying relational data store.

This method is always called before any OnConfigureXxxCommand. (inherited from DiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method OnRemove (Overloaded) By obtaining for each entity a data command via OnConfigureDeleteCommand(TDataCommand,TEntity) and then running that command, this inversion control method handles the request to delete a set of entities from the underlying relational data store. (inherited from DiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method OnRemoveAll By obtaining a data command via OnConfigureDeleteCommand(TDataCommand) and then running that command, this inversion control method handles the request to delete all entities from the underlying relational data store. (inherited from DiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Protected method OnSynchronize (Overloaded) By calling OnSynchronize(IEnumerable<TEntity>) over a single entity, this inversion control method handles the request to synchronize an entity, so that the create or update operations are accordingly performed into the underlying data source. (inherited from Dao<TEntity, TEntityCollection, TDataContext, TFilteringCriteria, TOrderingCriteria, TPagingCriteria, TCarboniteController, TTransaction, TTransactionCreationParameters>).
Protected method OnUpdate (Overloaded) By obtaining for each entity a data command via OnConfigureUpdateCommand(TDataCommand,TEntity) and then running that command, this inversion control method handles the request to update a set of entities into the underlying relational data store. (inherited from DiamantDao<TEntity, TDataContext, TDataCommand, TDataReader>).
Public method Static ReferenceEquals Determines whether the specified Object instances are the same instance. (inherited from Object).
Public method Remove (Overloaded) Routes an entity deletion request to the underlying data store. (inherited from Dao<TEntity, TEntityCollection, TDataContext, TFilteringCriteria, TOrderingCriteria, TPagingCriteria, TCarboniteController, TTransaction, TTransactionCreationParameters>).
Public method RemoveAll Routes a delete all entities request to the underlying data store. (inherited from Dao<TEntity, TEntityCollection, TDataContext, TFilteringCriteria, TOrderingCriteria, TPagingCriteria, TCarboniteController, TTransaction, TTransactionCreationParameters>).
Public method Synchronize (Overloaded) Routes an entity synchronization request to the underlying data store, so that the create or update operations are accordingly performed. (inherited from Dao<TEntity, TEntityCollection, TDataContext, TFilteringCriteria, TOrderingCriteria, TPagingCriteria, TCarboniteController, TTransaction, TTransactionCreationParameters>).
Public method ToString Returns a string that represents the current object. (inherited from Object).
Public method Update (Overloaded) Routes an entity update request to the underlying data store. (inherited from Dao<TEntity, TEntityCollection, TDataContext, TFilteringCriteria, TOrderingCriteria, TPagingCriteria, TCarboniteController, TTransaction, TTransactionCreationParameters>).
Top
Extension Methods
Name Description
Public extension method FromNullable Converts object values to nullable relational data store values. (Defined by Object_ToNullable).
Public extension method GetAttribute Obtains the first attribute that decorates an object class. (Defined by Attribute_GetAttributes).
Public extension method GetAttribute<TAtribute> (Overloaded) Obtains the first attribute that decorates an object class. (Defined by Attribute_GetAttributes).
Public extension method GetAttributes Obtains the attributes that decorates a class. (Defined by Attribute_GetAttributes).
Public extension method GetAttributes<TAtribute> (Overloaded) Obtains the attributes that decorates a class. (Defined by Attribute_GetAttributes).
Public extension method ToNullable<T> Converts nullable relational data store values to Nullable<T>. (Defined by Object_ToNullable).
Top
See Also